Exploring Microsoft Excel's Hidden Treasures by David Ringstrom

Author:David Ringstrom [David Ringstrom]
Language: eng
Format: epub
Publisher: Packt Publishing
Published: 2022-09-16T00:00:00+00:00

The Feature Comparison worksheet contains a Table Named Bridges that we’ll reference in our next example by writing a formula in segments without needing to switch between worksheets:

Type =COUNTIF(Bridges[ into cell V4 of the Formula References worksheet.

Tap the down arrow three times to choose Type of Bridge, as shown in Figure 7.17, and then press the Tab key to add the field name to your formula. Then, type in ] to close the field name:

Figure 7.17 – Referencing a Table on the Feature Comparison worksheet without switching sheets

Type ,U4) to finish the formula, and then press Enter to create a Calculated Column.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.